create procedure [dbo].[BAEImisTransGetAllByUserIdAndSourceSystem] @UserId as
varchar(10),
    @SourceSystem AS varchar(31),
    @StartDate AS DateTime,
    @EndDate AS DateTime
AS
    SELECT *  FROM Trans
    WHERE BT_ID = @UserId AND SOURCE_SYSTEM = @SourceSystem AND TRANSACTION_DATE BETWEEN @StartDate AND @EndDate
    AND (TRANSACTION_TYPE = 'PAY' OR TRANSACTION_TYPE = 'AR')
    ORDER BY TRANSACTION_DATE DESC;

GO